package com.qf.product.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.math.BigDecimal;
import java.util.Date;
import lombok.Data;


/**
   @author KING
   @ClassName: com.qf.product.entity.Specs
   @Description: 该类的功能描述
   @date: 2021/11/10 21:58 
*/
    

@Data
@TableName(value = "product_specs")
public class Specs {
    /**
     * 主键
     */
    @TableId(value = "product_specs_id", type = IdType.INPUT)
    private Integer productSpecsId;

    /**
     * 商品ID
     */
    @TableField(value = "product_id")
    private Long productId;

    /**
     * 商品SKU json格式 {"运行内存": "12G","颜色": "骚红","尺寸": "18cm"}
     */
    @TableField(value = "specs")
    private String specs;

    /**
     * 商品价格
     */
    @TableField(value = "price")
    private BigDecimal price;

    /**
     * 库存
     */
    @TableField(value = "stock")
    private Integer stock;

    /**
     * 库存预警值
     */
    @TableField(value = "low_stock")
    private Integer lowStock;

    /**
     * 创建时间
     */
    @TableField(value = "create_date")
    private Date createDate;

    @TableField(value = "update_date")
    private Date updateDate;

    /**
     * 1 表示正常 0 表示删除
     */
    @TableField(value = "`status`")
    private Integer status;

    public static final String COL_PRODUCT_SPECS_ID = "product_specs_id";

    public static final String COL_PRODUCT_ID = "product_id";

    public static final String COL_SPECS = "specs";

    public static final String COL_PRICE = "price";

    public static final String COL_STOCK = "stock";

    public static final String COL_LOW_STOCK = "low_stock";

    public static final String COL_CREATE_DATE = "create_date";

    public static final String COL_UPDATE_DATE = "update_date";

    public static final String COL_STATUS = "status";
}